Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TimePunchEntryID (FK)(PK) | A unique system-assigned identifier for this particular TimePunchEntry | ID_ENR_TPNCH | Identity | integer | WorkerTimePunchEntry(DO_TPNCH_WKR) |
CorrectionTimePunchEntryID (FK)(PK) | A unique system-assigned identifier for this particular TimePunchEntry | ID_ENR_TPNCH_CRTN | Identity | integer | WorkerTimePunchEntry(DO_TPNCH_WKR) |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
CorrectionDateTime | The date and time the Time Punch Correction was made. Not necessarily the time recorded on the correction WorkerTimePunchEntry. | DC_CRTN | AuditDateTime | datetime | |